Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	10841
Missing cells	1486
Missing cells (%)	1.1%
Duplicate rows	410
Duplicate rows (%)	3.8%
Total size in memory	1.1 MiB
Average record size in memory	104.0 B

Variable types

Text	5
Categorical	5
Numeric	2
DateTime	1

Alerts

Dataset has 410 (3.8%) duplicate rows	Duplicates
`Type` is highly imbalanced (62.0%)	Imbalance
`Content Rating` is highly imbalanced (61.5%)	Imbalance
`Rating` has 1474 (13.6%) missing values	Missing
`Reviews` has 596 (5.5%) zeros	Zeros

Reproduction

Analysis started	2025-02-04 20:58:06.107438
Analysis finished	2025-02-04 20:58:14.032345
Duration	7.92 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

App
Text

Distinct	9660
Distinct (%)	89.1%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Length

Max length	194
Median length	75
Mean length	22.517111
Min length	1

Characters and Unicode

Total characters	244108
Distinct characters	478
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8862 ?
Unique (%)	81.7%

Sample

1st row	Photo Editor & Candy Camera & Grid & ScrapBook
2nd row	Coloring book moana
3rd row	U Launcher Lite – FREE Live Cool Themes, Hide Apps
4th row	Sketch - Draw & Paint
5th row	Pixel Draw - Number Art Coloring Book

Value	Count	Frequency (%)
	2821	6.6%
for	560	1.3%
free	513	1.2%
app	332	0.8%
and	283	0.7%
the	270	0.6%
mobile	222	0.5%
news	195	0.5%
live	194	0.5%
video	194	0.5%
Other values (9549)	36995	86.9%

Most occurring characters

Value	Count	Frequency (%)
	31738	13.0%
e	19421	8.0%
a	14838	6.1%
o	13637	5.6%
r	13242	5.4%
i	12140	5.0%
t	10335	4.2%
n	9847	4.0%
s	8715	3.6%
l	8546	3.5%
Other values (468)	101649	41.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	244108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	31738	13.0%
e	19421	8.0%
a	14838	6.1%
o	13637	5.6%
r	13242	5.4%
i	12140	5.0%
t	10335	4.2%
n	9847	4.0%
s	8715	3.6%
l	8546	3.5%
Other values (468)	101649	41.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	244108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	31738	13.0%
e	19421	8.0%
a	14838	6.1%
o	13637	5.6%
r	13242	5.4%
i	12140	5.0%
t	10335	4.2%
n	9847	4.0%
s	8715	3.6%
l	8546	3.5%
Other values (468)	101649	41.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	244108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	31738	13.0%
e	19421	8.0%
a	14838	6.1%
o	13637	5.6%
r	13242	5.4%
i	12140	5.0%
t	10335	4.2%
n	9847	4.0%
s	8715	3.6%
l	8546	3.5%
Other values (468)	101649	41.6%

Category
Categorical

Distinct	33
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Memory size	84.8 KiB

FAMILY	1972
GAME	1144
TOOLS	843
MEDICAL	463
BUSINESS	460
Other values (28)	5958

Length

Max length	19
Median length	16
Mean length	9.0244465
Min length	4

Characters and Unicode

Total characters	97825
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ART_AND_DESIGN
2nd row	ART_AND_DESIGN
3rd row	ART_AND_DESIGN
4th row	ART_AND_DESIGN
5th row	ART_AND_DESIGN

Common Values

Value	Count	Frequency (%)
FAMILY	1972	18.2%
GAME	1144	10.6%
TOOLS	843	7.8%
MEDICAL	463	4.3%
BUSINESS	460	4.2%
PRODUCTIVITY	424	3.9%
PERSONALIZATION	392	3.6%
COMMUNICATION	387	3.6%
SPORTS	384	3.5%
LIFESTYLE	382	3.5%
Other values (23)	3989	36.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
family	1972	18.2%
game	1144	10.6%
tools	843	7.8%
medical	463	4.3%
business	460	4.2%
productivity	424	3.9%
personalization	392	3.6%
communication	387	3.6%
sports	384	3.5%
lifestyle	382	3.5%
Other values (23)	3989	36.8%

Most occurring characters

Value	Count	Frequency (%)
A	10424	10.7%
I	8783	9.0%
E	7958	8.1%
N	7335	7.5%
O	7125	7.3%
S	6558	6.7%
L	6189	6.3%
T	5894	6.0%
M	5155	5.3%
_	3575	3.7%
Other values (14)	28829	29.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	97825	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	10424	10.7%
I	8783	9.0%
E	7958	8.1%
N	7335	7.5%
O	7125	7.3%
S	6558	6.7%
L	6189	6.3%
T	5894	6.0%
M	5155	5.3%
_	3575	3.7%
Other values (14)	28829	29.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	97825	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	10424	10.7%
I	8783	9.0%
E	7958	8.1%
N	7335	7.5%
O	7125	7.3%
S	6558	6.7%
L	6189	6.3%
T	5894	6.0%
M	5155	5.3%
_	3575	3.7%
Other values (14)	28829	29.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	97825	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	10424	10.7%
I	8783	9.0%
E	7958	8.1%
N	7335	7.5%
O	7125	7.3%
S	6558	6.7%
L	6189	6.3%
T	5894	6.0%
M	5155	5.3%
_	3575	3.7%
Other values (14)	28829	29.5%

Rating
Real number (ℝ)

Missing

Distinct	39
Distinct (%)	0.4%
Missing	1474
Missing (%)	13.6%
Infinite	0
Infinite (%)	0.0%
Mean	4.1915128

Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3.2
Q1	4
median	4.3
Q3	4.5
95-th percentile	4.8
Maximum	5
Range	4
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.51573524
Coefficient of variation (CV)	0.12304275
Kurtosis	5.7889866
Mean	4.1915128
Median Absolute Deviation (MAD)	0.2
Skewness	-1.8518947
Sum	39261.9
Variance	0.26598284
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
4.4	1109	10.2%
4.3	1076	9.9%
4.5	1038	9.6%
4.2	952	8.8%
4.6	823	7.6%
4.1	708	6.5%
4	568	5.2%
4.7	499	4.6%
3.9	386	3.6%
3.8	303	2.8%
Other values (29)	1905	17.6%
(Missing)	1474	13.6%

Value	Count	Frequency (%)
1	16	0.1%
1.2	1	< 0.1%
1.4	3	< 0.1%
1.5	3	< 0.1%
1.6	4	< 0.1%
1.7	8	0.1%
1.8	8	0.1%
1.9	14	0.1%
2	12	0.1%
2.1	8	0.1%

Value	Count	Frequency (%)
5	274	2.5%
4.9	87	0.8%
4.8	234	2.2%
4.7	499	4.6%
4.6	823	7.6%
4.5	1038	9.6%
4.4	1109	10.2%
4.3	1076	9.9%
4.2	952	8.8%
4.1	708	6.5%

Reviews
Real number (ℝ)

Zeros

Distinct	6001
Distinct (%)	55.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	444111.93

Minimum	0
Maximum	78158306
Zeros	596
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	84.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	38
median	2094
Q3	54768
95-th percentile	1461698
Maximum	78158306
Range	78158306
Interquartile range (IQR)	54730

Descriptive statistics

Standard deviation	2927628.7
Coefficient of variation (CV)	6.5920964
Kurtosis	341.09154
Mean	444111.93
Median Absolute Deviation (MAD)	2094
Skewness	16.450332
Sum	4.8146174 × 10⁹
Variance	8.5710096 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	596	5.5%
1	272	2.5%
2	214	2.0%
3	175	1.6%
4	137	1.3%
5	108	1.0%
6	97	0.9%
7	90	0.8%
8	74	0.7%
9	65	0.6%
Other values (5991)	9013	83.1%

Value	Count	Frequency (%)
0	596	5.5%
1	272	2.5%
2	214	2.0%
3	175	1.6%
4	137	1.3%
5	108	1.0%
6	97	0.9%
7	90	0.8%
8	74	0.7%
9	65	0.6%

Value	Count	Frequency (%)
78158306	1	< 0.1%
78128208	1	< 0.1%
69119316	2	< 0.1%
69109672	1	< 0.1%
66577446	1	< 0.1%
66577313	2	< 0.1%
66509917	1	< 0.1%
56646578	1	< 0.1%
56642847	2	< 0.1%
44893888	1	< 0.1%

Size
Text

Distinct	461
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Length

Max length	18
Median length	5
Mean length	5.7052855
Min length	3

Characters and Unicode

Total characters	61851
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	245 ?
Unique (%)	2.3%

Sample

1st row	19M
2nd row	14M
3rd row	8.7M
4th row	25M
5th row	2.8M

Value	Count	Frequency (%)
varies	1695	11.9%
with	1695	11.9%
device	1695	11.9%
11m	198	1.4%
12m	196	1.4%
14m	194	1.4%
13m	191	1.3%
15m	184	1.3%
17m	160	1.1%
19m	154	1.1%
Other values (453)	7869	55.3%

Most occurring characters

Value	Count	Frequency (%)
M	8830	14.3%
e	5085	8.2%
i	5085	8.2%
.	3610	5.8%
	3390	5.5%
1	3095	5.0%
2	2791	4.5%
3	2343	3.8%
4	1966	3.2%
5	1741	2.8%
Other values (16)	23915	38.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	61851	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	8830	14.3%
e	5085	8.2%
i	5085	8.2%
.	3610	5.8%
	3390	5.5%
1	3095	5.0%
2	2791	4.5%
3	2343	3.8%
4	1966	3.2%
5	1741	2.8%
Other values (16)	23915	38.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	61851	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	8830	14.3%
e	5085	8.2%
i	5085	8.2%
.	3610	5.8%
	3390	5.5%
1	3095	5.0%
2	2791	4.5%
3	2343	3.8%
4	1966	3.2%
5	1741	2.8%
Other values (16)	23915	38.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	61851	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	8830	14.3%
e	5085	8.2%
i	5085	8.2%
.	3610	5.8%
	3390	5.5%
1	3095	5.0%
2	2791	4.5%
3	2343	3.8%
4	1966	3.2%
5	1741	2.8%
Other values (16)	23915	38.7%

Installs
Categorical

Distinct	21
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

1,000,000+	1579
10,000,000+	1252
100,000+	1169
10,000+	1054
1,000+	908
Other values (16)	4879

Length

Max length	14
Median length	11
Mean length	7.9186422
Min length	1

Characters and Unicode

Total characters	85846
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	10,000+
2nd row	500,000+
3rd row	5,000,000+
4th row	50,000,000+
5th row	100,000+

Common Values

Value	Count	Frequency (%)
1,000,000+	1579	14.6%
10,000,000+	1252	11.5%
100,000+	1169	10.8%
10,000+	1054	9.7%
1,000+	908	8.4%
5,000,000+	752	6.9%
100+	719	6.6%
500,000+	539	5.0%
50,000+	479	4.4%
5,000+	477	4.4%
Other values (11)	1913	17.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1,000,000	1579	14.6%
10,000,000	1252	11.5%
100,000	1169	10.8%
10,000	1054	9.7%
1,000	908	8.4%
5,000,000	752	6.9%
100	719	6.6%
500,000	539	5.0%
50,000	479	4.4%
5,000	477	4.4%
Other values (10)	1913	17.6%

Most occurring characters

Value	Count	Frequency (%)
0	50674	59.0%
,	13506	15.7%
+	10840	12.6%
1	7601	8.9%
5	3225	3.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	85846	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	50674	59.0%
,	13506	15.7%
+	10840	12.6%
1	7601	8.9%
5	3225	3.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	85846	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	50674	59.0%
,	13506	15.7%
+	10840	12.6%
1	7601	8.9%
5	3225	3.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	85846	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	50674	59.0%
,	13506	15.7%
+	10840	12.6%
1	7601	8.9%
5	3225	3.8%

Type
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	84.8 KiB

Free	10040
Paid	800

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	43360
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Free
2nd row	Free
3rd row	Free
4th row	Free
5th row	Free

Common Values

Value	Count	Frequency (%)
Free	10040	92.6%
Paid	800	7.4%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
free	10040	92.6%
paid	800	7.4%

Most occurring characters

Value	Count	Frequency (%)
e	20080	46.3%
F	10040	23.2%
r	10040	23.2%
P	800	1.8%
a	800	1.8%
i	800	1.8%
d	800	1.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	43360	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	20080	46.3%
F	10040	23.2%
r	10040	23.2%
P	800	1.8%
a	800	1.8%
i	800	1.8%
d	800	1.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	43360	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	20080	46.3%
F	10040	23.2%
r	10040	23.2%
P	800	1.8%
a	800	1.8%
i	800	1.8%
d	800	1.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	43360	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	20080	46.3%
F	10040	23.2%
r	10040	23.2%
P	800	1.8%
a	800	1.8%
i	800	1.8%
d	800	1.8%

Price
Text

Distinct	92
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Length

Max length	8
Median length	1
Mean length	1.3793008
Min length	1

Characters and Unicode

Total characters	14953
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	53 ?
Unique (%)	0.5%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	10041	92.6%
0.99	148	1.4%
2.99	129	1.2%
1.99	73	0.7%
4.99	72	0.7%
3.99	63	0.6%
1.49	46	0.4%
5.99	30	0.3%
2.49	26	0.2%
9.99	21	0.2%
Other values (82)	192	1.8%

Most occurring characters

Value	Count	Frequency (%)
0	10246	68.5%
9	1477	9.9%
$	800	5.4%
.	800	5.4%
	800	5.4%
4	220	1.5%
2	193	1.3%
1	189	1.3%
3	104	0.7%
5	52	0.3%
Other values (3)	72	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14953	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	10246	68.5%
9	1477	9.9%
$	800	5.4%
.	800	5.4%
	800	5.4%
4	220	1.5%
2	193	1.3%
1	189	1.3%
3	104	0.7%
5	52	0.3%
Other values (3)	72	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14953	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	10246	68.5%
9	1477	9.9%
$	800	5.4%
.	800	5.4%
	800	5.4%
4	220	1.5%
2	193	1.3%
1	189	1.3%
3	104	0.7%
5	52	0.3%
Other values (3)	72	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14953	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	10246	68.5%
9	1477	9.9%
$	800	5.4%
.	800	5.4%
	800	5.4%
4	220	1.5%
2	193	1.3%
1	189	1.3%
3	104	0.7%
5	52	0.3%
Other values (3)	72	0.5%

Content Rating
Categorical

Imbalance

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Everyone	8715
Teen	1208
Mature 17+	499
Everyone 10+	414
Adults only 18+	3

Length

Max length	15
Median length	8
Mean length	7.8008486
Min length	4

Characters and Unicode

Total characters	84569
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Everyone
2nd row	Everyone
3rd row	Everyone
4th row	Teen
5th row	Everyone

Common Values

Value	Count	Frequency (%)
Everyone	8715	80.4%
Teen	1208	11.1%
Mature 17+	499	4.6%
Everyone 10+	414	3.8%
Adults only 18+	3	< 0.1%
Unrated	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
everyone	9129	77.6%
teen	1208	10.3%
mature	499	4.2%
17	499	4.2%
10	414	3.5%
adults	3	< 0.1%
only	3	< 0.1%
18	3	< 0.1%
unrated	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	21175	25.0%
n	10342	12.2%
r	9630	11.4%
y	9132	10.8%
o	9132	10.8%
v	9129	10.8%
E	9129	10.8%
T	1208	1.4%
	919	1.1%
1	916	1.1%
Other values (13)	3857	4.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84569	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	21175	25.0%
n	10342	12.2%
r	9630	11.4%
y	9132	10.8%
o	9132	10.8%
v	9129	10.8%
E	9129	10.8%
T	1208	1.4%
	919	1.1%
1	916	1.1%
Other values (13)	3857	4.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84569	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	21175	25.0%
n	10342	12.2%
r	9630	11.4%
y	9132	10.8%
o	9132	10.8%
v	9129	10.8%
E	9129	10.8%
T	1208	1.4%
	919	1.1%
1	916	1.1%
Other values (13)	3857	4.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84569	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	21175	25.0%
n	10342	12.2%
r	9630	11.4%
y	9132	10.8%
o	9132	10.8%
v	9129	10.8%
E	9129	10.8%
T	1208	1.4%
	919	1.1%
1	916	1.1%
Other values (13)	3857	4.6%

Genres
Text

Distinct	120
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Length

Max length	37
Median length	32
Mean length	10.421917
Min length	4

Characters and Unicode

Total characters	112984
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.2%

Sample

1st row	Art & Design
2nd row	Art & Design;Pretend Play
3rd row	Art & Design
4th row	Art & Design
5th row	Art & Design;Creativity

Value	Count	Frequency (%)
	2073	13.4%
tools	842	5.5%
entertainment	623	4.0%
education	549	3.6%
medical	463	3.0%
business	460	3.0%
productivity	424	2.7%
sports	398	2.6%
personalization	392	2.5%
communication	387	2.5%
Other values (126)	8837	57.2%

Most occurring characters

Value	Count	Frequency (%)
i	9816	8.7%
o	9089	8.0%
e	8940	7.9%
n	8905	7.9%
t	8623	7.6%
a	8618	7.6%
s	6282	5.6%
	4607	4.1%
l	4601	4.1%
r	4532	4.0%
Other values (36)	38971	34.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	112984	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	9816	8.7%
o	9089	8.0%
e	8940	7.9%
n	8905	7.9%
t	8623	7.6%
a	8618	7.6%
s	6282	5.6%
	4607	4.1%
l	4601	4.1%
r	4532	4.0%
Other values (36)	38971	34.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	112984	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	9816	8.7%
o	9089	8.0%
e	8940	7.9%
n	8905	7.9%
t	8623	7.6%
a	8618	7.6%
s	6282	5.6%
	4607	4.1%
l	4601	4.1%
r	4532	4.0%
Other values (36)	38971	34.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	112984	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	9816	8.7%
o	9089	8.0%
e	8940	7.9%
n	8905	7.9%
t	8623	7.6%
a	8618	7.6%
s	6282	5.6%
	4607	4.1%
l	4601	4.1%
r	4532	4.0%
Other values (36)	38971	34.5%

Last Updated
Date

Distinct	1377
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Memory size	84.8 KiB

Minimum	2010-05-21 00:00:00
Maximum	2018-08-08 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Current Ver
Text

Distinct	2783
Distinct (%)	25.7%
Missing	8
Missing (%)	0.1%
Memory size	84.8 KiB

Length

Max length	50
Median length	39
Mean length	6.6437737
Min length	1

Characters and Unicode

Total characters	71972
Distinct characters	79
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1784 ?
Unique (%)	16.5%

Sample

1st row	1.0.0
2nd row	2.0.0
3rd row	1.2.4
4th row	Varies with device
5th row	1.1

Value	Count	Frequency (%)
varies	1459	10.5%
with	1459	10.5%
device	1459	10.5%
1	844	6.1%
1.1	278	2.0%
1.2	185	1.3%
2	166	1.2%
1.3	147	1.1%
1.0.0	136	1.0%
1.0.1	120	0.9%
Other values (2824)	7674	55.1%

Most occurring characters

Value	Count	Frequency (%)
.	14308	19.9%
1	8918	12.4%
0	4540	6.3%
e	4508	6.3%
i	4464	6.2%
2	4316	6.0%
	3094	4.3%
3	2771	3.9%
4	2164	3.0%
5	1729	2.4%
Other values (69)	21160	29.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	71972	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	14308	19.9%
1	8918	12.4%
0	4540	6.3%
e	4508	6.3%
i	4464	6.2%
2	4316	6.0%
	3094	4.3%
3	2771	3.9%
4	2164	3.0%
5	1729	2.4%
Other values (69)	21160	29.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	71972	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	14308	19.9%
1	8918	12.4%
0	4540	6.3%
e	4508	6.3%
i	4464	6.2%
2	4316	6.0%
	3094	4.3%
3	2771	3.9%
4	2164	3.0%
5	1729	2.4%
Other values (69)	21160	29.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	71972	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	14308	19.9%
1	8918	12.4%
0	4540	6.3%
e	4508	6.3%
i	4464	6.2%
2	4316	6.0%
	3094	4.3%
3	2771	3.9%
4	2164	3.0%
5	1729	2.4%
Other values (69)	21160	29.4%

Android Ver
Categorical

Distinct	33
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	84.8 KiB

4.1 and up	2451
4.0.3 and up	1501
4.0 and up	1376
Varies with device	1362
4.4 and up	980
Other values (28)	3169

Length

Max length	18
Median length	10
Mean length	11.337116
Min length	9

Characters and Unicode

Total characters	122883
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	4.0.3 and up
2nd row	4.0.3 and up
3rd row	4.0.3 and up
4th row	4.2 and up
5th row	4.4 and up

Common Values

Value	Count	Frequency (%)
4.1 and up	2451	22.6%
4.0.3 and up	1501	13.8%
4.0 and up	1376	12.7%
Varies with device	1362	12.6%
4.4 and up	980	9.0%
2.3 and up	652	6.0%
5.0 and up	601	5.5%
4.2 and up	394	3.6%
2.3.3 and up	281	2.6%
2.2 and up	244	2.3%
Other values (23)	997	9.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	9468	29.1%
up	9468	29.1%
4.1	2452	7.5%
4.0.3	1503	4.6%
4.0	1376	4.2%
varies	1362	4.2%
with	1362	4.2%
device	1362	4.2%
4.4	980	3.0%
2.3	652	2.0%
Other values (22)	2532	7.8%

Most occurring characters

Value	Count	Frequency (%)
	21678	17.6%
.	11283	9.2%
d	10830	8.8%
a	10830	8.8%
p	9468	7.7%
u	9468	7.7%
n	9468	7.7%
4	7952	6.5%
e	4086	3.3%
i	4086	3.3%
Other values (18)	23734	19.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122883	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	21678	17.6%
.	11283	9.2%
d	10830	8.8%
a	10830	8.8%
p	9468	7.7%
u	9468	7.7%
n	9468	7.7%
4	7952	6.5%
e	4086	3.3%
i	4086	3.3%
Other values (18)	23734	19.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122883	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	21678	17.6%
.	11283	9.2%
d	10830	8.8%
a	10830	8.8%
p	9468	7.7%
u	9468	7.7%
n	9468	7.7%
4	7952	6.5%
e	4086	3.3%
i	4086	3.3%
Other values (18)	23734	19.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122883	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	21678	17.6%
.	11283	9.2%
d	10830	8.8%
a	10830	8.8%
p	9468	7.7%
u	9468	7.7%
n	9468	7.7%
4	7952	6.5%
e	4086	3.3%
i	4086	3.3%
Other values (18)	23734	19.3%

	Android Ver	Category	Content Rating	Installs	Rating	Reviews	Type
Android Ver	1.000	0.090	0.051	0.099	0.070	0.000	0.187
Category	0.090	1.000	0.347	0.112	0.085	0.072	0.198
Content Rating	0.051	0.347	1.000	0.086	0.041	0.062	0.048
Installs	0.099	0.112	0.086	1.000	0.176	0.312	0.265
Rating	0.070	0.085	0.041	0.176	1.000	0.157	0.071
Reviews	0.000	0.072	0.062	0.312	0.157	1.000	0.017
Type	0.187	0.198	0.048	0.265	0.071	0.017	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	App	Category	Rating	Reviews	Size	Installs	Type	Content Rating	Genres	Last Updated	Current Ver	Android Ver
0	Photo Editor & Candy Camera & Grid & ScrapBook	ART_AND_DESIGN	4.1	159	19M	10,000+	Free	Everyone	Art & Design	7-Jan-18	1.0.0	4.0.3 and up
1	Coloring book moana	ART_AND_DESIGN	3.9	967	14M	500,000+	Free	Everyone	Art & Design;Pretend Play	15-Jan-18	2.0.0	4.0.3 and up
2	U Launcher Lite – FREE Live Cool Themes, Hide Apps	ART_AND_DESIGN	4.7	87510	8.7M	5,000,000+	Free	Everyone	Art & Design	1-Aug-18	1.2.4	4.0.3 and up
3	Sketch - Draw & Paint	ART_AND_DESIGN	4.5	215644	25M	50,000,000+	Free	Teen	Art & Design	8-Jun-18	Varies with device	4.2 and up
4	Pixel Draw - Number Art Coloring Book	ART_AND_DESIGN	4.3	967	2.8M	100,000+	Free	Everyone	Art & Design;Creativity	20-Jun-18	1.1	4.4 and up
5	Paper flowers instructions	ART_AND_DESIGN	4.4	167	5.6M	50,000+	Free	Everyone	Art & Design	26-Mar-17	1	2.3 and up
6	Smoke Effect Photo Maker - Smoke Editor	ART_AND_DESIGN	3.8	178	19M	50,000+	Free	Everyone	Art & Design	26-Apr-18	1.1	4.0.3 and up
7	Infinite Painter	ART_AND_DESIGN	4.1	36815	29M	1,000,000+	Free	Everyone	Art & Design	14-Jun-18	6.1.61.1	4.2 and up
8	Garden Coloring Book	ART_AND_DESIGN	4.4	13791	33M	1,000,000+	Free	Everyone	Art & Design	20-Sep-17	2.9.2	3.0 and up
9	Kids Paint Free - Drawing Fun	ART_AND_DESIGN	4.7	121	3.1M	10,000+	Free	Everyone	Art & Design;Creativity	3-Jul-18	2.8	4.0.3 and up

	App	Category	Rating	Reviews	Size	Installs	Type	Content Rating	Genres	Last Updated	Current Ver	Android Ver
10831	payermonstationnement.fr	MAPS_AND_NAVIGATION	NaN	38	9.8M	5,000+	Free	Everyone	Maps & Navigation	13-Jun-18	2.0.148.0	4.0 and up
10832	FR Tides	WEATHER	3.8	1195	582k	100,000+	Free	Everyone	Weather	16-Feb-14	6	2.1 and up
10833	Chemin (fr)	BOOKS_AND_REFERENCE	4.8	44	619k	1,000+	Free	Everyone	Books & Reference	23-Mar-14	0.8	2.2 and up
10834	FR Calculator	FAMILY	4.0	7	2.6M	500+	Free	Everyone	Education	18-Jun-17	1.0.0	4.1 and up
10835	FR Forms	BUSINESS	NaN	0	9.6M	10+	Free	Everyone	Business	29-Sep-16	1.1.5	4.0 and up
10836	Sya9a Maroc - FR	FAMILY	4.5	38	53M	5,000+	Free	Everyone	Education	25-Jul-17	1.48	4.1 and up
10837	Fr. Mike Schmitz Audio Teachings	FAMILY	5.0	4	3.6M	100+	Free	Everyone	Education	6-Jul-18	1	4.1 and up
10838	Parkinson Exercices FR	MEDICAL	NaN	3	9.5M	1,000+	Free	Everyone	Medical	20-Jan-17	1	2.2 and up
10839	The SCP Foundation DB fr nn5n	BOOKS_AND_REFERENCE	4.5	114	Varies with device	1,000+	Free	Mature 17+	Books & Reference	19-Jan-15	Varies with device	Varies with device
10840	iHoroscope - 2018 Daily Horoscope & Astrology	LIFESTYLE	4.5	398307	19M	10,000,000+	Free	Everyone	Lifestyle	25-Jul-18	Varies with device	Varies with device

Most frequently occurring

	App	Category	Rating	Reviews	Size	Installs	Type	Content Rating	Genres	Last Updated	Current Ver	Android Ver	# duplicates
59	CBS Sports App - Scores, News, Stats & Watch Live	SPORTS	4.3	91031	Varies with device	5,000,000+	Free	Everyone	Sports	4-Aug-18	Varies with device	5.0 and up	4
159	Google Keep	PRODUCTIVITY	4.4	691474	Varies with device	100,000,000+	Free	Everyone	Productivity	6-Aug-18	Varies with device	Varies with device	4
253	Nick	ENTERTAINMENT	4.2	123279	25M	10,000,000+	Free	Everyone 10+	Entertainment;Music & Video	24-Jan-18	2.0.8	4.4 and up	4
285	Quizlet: Learn Languages & Vocab with Flashcards	EDUCATION	4.6	211856	Varies with device	10,000,000+	Free	Everyone	Education	1-Aug-18	Varies with device	Varies with device	4
316	Skyscanner	TRAVEL_AND_LOCAL	4.5	481546	29M	10,000,000+	Free	Everyone	Travel & Local	6-Aug-18	5.48	4.4 and up	4
372	WatchESPN	SPORTS	4.1	288809	6.6M	10,000,000+	Free	Everyone	Sports	27-Sep-17	2.5.1	4.4 and up	4
395	eBay: Buy & Sell this Summer - Discover Deals Now!	SHOPPING	4.4	2788923	Varies with device	100,000,000+	Free	Teen	Shopping	30-Jul-18	Varies with device	Varies with device	4
7	A&E - Watch Full Episodes of TV Shows	ENTERTAINMENT	4.0	29706	19M	1,000,000+	Free	Teen	Entertainment	16-Jul-18	3.1.4	4.4 and up	3
14	Adult Dirty Emojis	DATING	2.8	80	5.5M	10,000+	Free	Teen	Dating	6-Nov-17	1	4.0.3 and up	3
28	BBC News	NEWS_AND_MAGAZINES	4.3	296781	Varies with device	10,000,000+	Free	Everyone 10+	News & Magazines	24-Jul-18	Varies with device	Varies with device	3

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks